package com.lhj.xxsc.product.service.impl;

import com.xxsc.common.constant.ProductConstant;
import com.xxsc.common.to.SkuHasStockVo;
import com.xxsc.common.to.SkuReductionTo;
import com.xxsc.common.to.SpuBoundTo;
import com.xxsc.common.to.es.SkuEsModel;
import com.xxsc.common.utils.R;
import com.lhj.xxsc.product.entity.*;
import com.lhj.xxsc.product.feign.CouponFeignService;
import com.lhj.xxsc.product.feign.SearchFeignService;
import com.lhj.xxsc.product.feign.WareFeignService;
import com.lhj.xxsc.product.service.*;
import com.lhj.xxsc.product.vo.*;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.xxsc.common.utils.PageUtils;
import com.xxsc.common.utils.Query;

import com.lhj.xxsc.product.dao.SpuInfoDao;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;


@Service("spuInfoService")
public class SpuInfoServiceImpl extends ServiceImpl<SpuInfoDao, SpuInfoEntity> implements SpuInfoService {

	@Autowired
	SpuInfoDescService spuInfoDescService;

	@Autowired
	SpuImagesService imagesService;

	@Autowired
	AttrService attrService;

	@Autowired
	ProductAttrValueService attrValueService;

	@Autowired
	SkuInfoService skuInfoService;
	@Autowired
	SkuImagesService skuImagesService;

	@Autowired
	SkuSaleAttrValueService skuSaleAttrValueService;

	@Autowired
	CouponFeignService couponFeignService;

	@Autowired
	BrandService brandService;

	@Autowired
	CategoryService categoryService;

	@Autowired
	WareFeignService wareFeignService;

	@Autowired
	SearchFeignService searchFeignService;

	@Override
	public PageUtils queryPage(Map<String, Object> params) {
		IPage<SpuInfoEntity> page = this.page(
				new Query<SpuInfoEntity>().getPage(params),
				new QueryWrapper<SpuInfoEntity>()
		);

		return new PageUtils(page);
	}

	/**
	 * //TODO 高级部分完善
	 *
	 * @param vo
	 */
	@Transactional
	@Override
	public void saveSpuInfo(SpuSaveVo vo) {

		// 1.保存 spu 基本信息 pms_spu_info
		SpuInfoEntity spuInfoEntity = new SpuInfoEntity();
		BeanUtils.copyProperties(vo, spuInfoEntity);
		spuInfoEntity.setCreateTime(new Date());
		spuInfoEntity.setUpdateTime(new Date());
		this.saveBaseSpuInfo(spuInfoEntity);

		// 2.保存 spu 的描述图片 pms_spu_info_desc
		List<String> decript = vo.getDecript();
		SpuInfoDescEntity spuInfoDescEntity = new SpuInfoDescEntity();
		spuInfoDescEntity.setSpuId(spuInfoEntity.getId());
		spuInfoDescEntity.setDecript(String.join(",", decript));
		spuInfoDescService.saveSpuInfoDesc(spuInfoDescEntity);

		// 3.保存 spu 的图片集 pms_spu_images 图片集
		List<String> images = vo.getImages();
		imagesService.saveImages(spuInfoEntity.getId(), images);

		// 4.保存 spu 保存规格属性的值；pms_product_attr_value
		List<BaseAttrs> baseAttrs = vo.getBaseAttrs();
		List<ProductAttrValueEntity> collect = baseAttrs.stream().map(
				attr -> {
					ProductAttrValueEntity valueEntity = new ProductAttrValueEntity();
					valueEntity.setAttrId(attr.getAttrId());
					AttrEntity attrEntity = attrService.getById(attr.getAttrId());
					valueEntity.setAttrName(attrEntity.getAttrName());
					valueEntity.setAttrValue(attr.getAttrValues());
					valueEntity.setQuickShow(attr.getShowDesc());
					valueEntity.setSpuId(spuInfoEntity.getId());
					return valueEntity;
				}
		).collect(Collectors.toList());
		// 保存规格属性的值
		attrValueService.saveProductAttr(collect);

		// 5.保存 spu 的积分信息：
		Bounds bounds = vo.getBounds();
		SpuBoundTo spuBoundTo = new SpuBoundTo();
		BeanUtils.copyProperties(bounds, spuBoundTo);
		spuBoundTo.setSpuId(spuInfoEntity.getId());
		R r = couponFeignService.saveSpuBounds(spuBoundTo);
		if (r.getCode() != 0) {
			log.error("远程保存spu积分信息失败");
		}

		// 6.保存 spu 的所有sku 信息
		List<Skus> skus = vo.getSkus();
		if (!CollectionUtils.isEmpty(skus)) {
			skus.forEach(
					item -> {
						String defaultImg = "";
						for (Images image : item.getImages()) {
							if (image.getDefaultImg() == 1) {
								defaultImg = image.getImgUrl();
							}
						}
						SkuInfoEntity skuInfoEntity = new SkuInfoEntity();
						BeanUtils.copyProperties(item, skuInfoEntity);
						skuInfoEntity.setBrandId(spuInfoEntity.getBrandId());
						skuInfoEntity.setCatalogId(spuInfoEntity.getCatalogId());
						skuInfoEntity.setSaleCount(0L);
						skuInfoEntity.setSpuId(spuInfoEntity.getId());
						skuInfoEntity.setSkuDefaultImg(defaultImg);
						// 6.1 sku的基本信息；pms_sku_info
						skuInfoService.saveSkuInfo(skuInfoEntity);

						Long skuId = skuInfoEntity.getSkuId();

						List<SkuImagesEntity> imagesEntities = item.getImages().stream().map(
								(img) -> {
									SkuImagesEntity skuImagesEntity = new SkuImagesEntity();
									skuImagesEntity.setSkuId(skuId);
									skuImagesEntity.setImgUrl(img.getImgUrl());
									skuImagesEntity.setDefaultImg(img.getDefaultImg());
									return skuImagesEntity;
								}
						).filter(
								entity -> {
									return !StringUtils.isEmpty(entity.getImgUrl());
								}
						).collect(Collectors.toList());

						// 6.2 sku的图片信息；pms_sku_image
						skuImagesService.saveBatch(imagesEntities);
						// TODO 没有 图片路径无须保存


						List<Attr> attr = item.getAttr();
						List<SkuSaleAttrValueEntity> skuSaleAttrValueEntities = attr.stream().map(
								a -> {
									SkuSaleAttrValueEntity skuSaleAttrValueEntity = new SkuSaleAttrValueEntity();
									BeanUtils.copyProperties(a, skuSaleAttrValueEntity);
									skuSaleAttrValueEntity.setSkuId(skuId);
									return skuSaleAttrValueEntity;
								}
						).collect(Collectors.toList());
						// 6.3 sku的销售属性信息：pms_sku_sale_attr_value
						skuSaleAttrValueService.saveBatch(skuSaleAttrValueEntities);

						// 6.4 sku的优惠、满减等信息；gulimall_sms->sms_sku_ladder\sms_sku_full_reduction\sms_member_price
						SkuReductionTo skuReductionTo = new SkuReductionTo();
						BeanUtils.copyProperties(item, skuReductionTo);
						skuReductionTo.setSkuId(skuId);
						if (skuReductionTo.getFullCount() > 0 || skuReductionTo.getFullPrice().compareTo(new BigDecimal("0")) == 1) {
							R r1 = couponFeignService.saveSkuReduction(skuReductionTo);
							if (r1.getCode() != 0) {
								log.error("远程保存sku优惠信息失败");
							}
						}

					}
			);
		}
/*

        //1、保存spu基本信息 pms_spu_info
        SpuInfoEntity infoEntity = new SpuInfoEntity();
        BeanUtils.copyProperties(vo,infoEntity);
        infoEntity.setCreateTime(new Date());
        infoEntity.setUpdateTime(new Date());
        this.saveBaseSpuInfo(infoEntity);

        //2、保存Spu的描述图片 pms_spu_info_desc
        List<String> decript = vo.getDecript();
        SpuInfoDescEntity descEntity = new SpuInfoDescEntity();
        descEntity.setSpuId(infoEntity.getId());
        descEntity.setDecript(String.join(",",decript));
        spuInfoDescService.saveSpuInfoDesc(descEntity);



        //3、保存spu的图片集 pms_spu_images
        List<String> images = vo.getImages();
        imagesService.saveImages(infoEntity.getId(),images);


        //4、保存spu的规格参数;pms_product_attr_value
        List<BaseAttrs> baseAttrs = vo.getBaseAttrs();
        List<ProductAttrValueEntity> collect = baseAttrs.stream().map(attr -> {
            ProductAttrValueEntity valueEntity = new ProductAttrValueEntity();
            valueEntity.setAttrId(attr.getAttrId());
            AttrEntity id = attrService.getById(attr.getAttrId());
            valueEntity.setAttrName(id.getAttrName());
            valueEntity.setAttrValue(attr.getAttrValues());
            valueEntity.setQuickShow(attr.getShowDesc());
            valueEntity.setSpuId(infoEntity.getId());

            return valueEntity;
        }).collect(Collectors.toList());
        attrValueService.saveProductAttr(collect);


        //5、保存spu的积分信息；gulimall_sms->sms_spu_bounds
        Bounds bounds = vo.getBounds();
        SpuBoundTo spuBoundTo = new SpuBoundTo();
        BeanUtils.copyProperties(bounds,spuBoundTo);
        spuBoundTo.setSpuId(infoEntity.getId());
        R r = couponFeignService.saveSpuBounds(spuBoundTo);
        if(r.getCode() != 0){
            log.error("远程保存spu积分信息失败");
        }


        //5、保存当前spu对应的所有sku信息；

        List<Skus> skus = vo.getSkus();
        if(skus!=null && skus.size()>0){
            skus.forEach(item->{
                String defaultImg = "";
                for (Images image : item.getImages()) {
                    if(image.getDefaultImg() == 1){
                        defaultImg = image.getImgUrl();
                    }
                }
                //    private String skuName;
                //    private BigDecimal price;
                //    private String skuTitle;
                //    private String skuSubtitle;
                SkuInfoEntity skuInfoEntity = new SkuInfoEntity();
                BeanUtils.copyProperties(item,skuInfoEntity);
                skuInfoEntity.setBrandId(infoEntity.getBrandId());
                skuInfoEntity.setCatalogId(infoEntity.getCatalogId());
                skuInfoEntity.setSaleCount(0L);
                skuInfoEntity.setSpuId(infoEntity.getId());
                skuInfoEntity.setSkuDefaultImg(defaultImg);
                //5.1）、sku的基本信息；pms_sku_info
                skuInfoService.saveSkuInfo(skuInfoEntity);

                Long skuId = skuInfoEntity.getSkuId();

                List<SkuImagesEntity> imagesEntities = item.getImages().stream().map(img -> {
                    SkuImagesEntity skuImagesEntity = new SkuImagesEntity();
                    skuImagesEntity.setSkuId(skuId);
                    skuImagesEntity.setImgUrl(img.getImgUrl());
                    skuImagesEntity.setDefaultImg(img.getDefaultImg());
                    return skuImagesEntity;
                }).filter(entity->{
                    //返回true就是需要，false就是剔除
                    return !StringUtils.isEmpty(entity.getImgUrl());
                }).collect(Collectors.toList());
                //5.2）、sku的图片信息；pms_sku_image
                skuImagesService.saveBatch(imagesEntities);
                //TODO 没有图片路径的无需保存

                List<Attr> attr = item.getAttr();
                List<SkuSaleAttrValueEntity> skuSaleAttrValueEntities = attr.stream().map(a -> {
                    SkuSaleAttrValueEntity attrValueEntity = new SkuSaleAttrValueEntity();
                    BeanUtils.copyProperties(a, attrValueEntity);
                    attrValueEntity.setSkuId(skuId);

                    return attrValueEntity;
                }).collect(Collectors.toList());
                //5.3）、sku的销售属性信息：pms_sku_sale_attr_value
                skuSaleAttrValueService.saveBatch(skuSaleAttrValueEntities);

                // //5.4）、sku的优惠、满减等信息；gulimall_sms->sms_sku_ladder\sms_sku_full_reduction\sms_member_price
                SkuReductionTo skuReductionTo = new SkuReductionTo();
                BeanUtils.copyProperties(item,skuReductionTo);
                skuReductionTo.setSkuId(skuId);
                if(skuReductionTo.getFullCount() >0 || skuReductionTo.getFullPrice().compareTo(new BigDecimal("0")) == 1){
                    R r1 = couponFeignService.saveSkuReduction(skuReductionTo);
                    if(r1.getCode() != 0){
                        log.error("远程保存sku优惠信息失败");
                    }
                }
            });
        }
*/


	}

	@Override
	public void saveBaseSpuInfo(SpuInfoEntity infoEntity) {
		this.baseMapper.insert(infoEntity);
	}

	@Override
	public PageUtils queryPageByCondition(Map<String, Object> params) {

		QueryWrapper<SpuInfoEntity> wrapper = new QueryWrapper<>();

		String key = (String) params.get("key");
		if (!StringUtils.isEmpty(key)) {
			wrapper.and((w) -> {
				w.eq("id", key).or().like("spu_name", key);
			});
		}
		// status=1 and (id=1 or spu_name like xxx)
		String status = (String) params.get("status");
		if (!StringUtils.isEmpty(status)) {
			wrapper.eq("publish_status", status);
		}

		String brandId = (String) params.get("brandId");
		if (!StringUtils.isEmpty(brandId) && !"0".equalsIgnoreCase(brandId)) {
			wrapper.eq("brand_id", brandId);
		}

		String catelogId = (String) params.get("catelogId");
		if (!StringUtils.isEmpty(catelogId) && !"0".equalsIgnoreCase(catelogId)) {
			wrapper.eq("catalog_id", catelogId);
		}

		/**
		 * status: 2
		 * key:
		 * brandId: 9
		 * catelogId: 225
		 */

		IPage<SpuInfoEntity> page = this.page(
				new Query<SpuInfoEntity>().getPage(params),
				wrapper
		);

		return new PageUtils(page);
	}


	/**
	 * 商品的上架
	 *
	 * @param spuId
	 */
	@Override
	public void up(Long spuId) {

		// 查出当前spuid对应的所有sku信息。品牌的名称等。
		List<SkuInfoEntity> skus = skuInfoService.getSkusBySpuId(spuId);

		// TODO 查出挡墙sku的可以用来被检索的规格属性
		// 根据spuId 查出对应的规格属性
		List<ProductAttrValueEntity> baseAttrs = attrValueService.baseAttrlistforspu(spuId);
		List<Long> attrIds = baseAttrs.stream().map(attr -> {
			return attr.getAttrId();
		}).collect(Collectors.toList());

		// 查看这些属性是不是可以被检索的 获取可以被检索的属性
		List<Long> searchAttrIds = attrService.selectSearchAttrs(attrIds);

		Set<Long> idSet = new HashSet<>(searchAttrIds);
		List<SkuEsModel> attrs = new ArrayList<>();
		// 先筛选出可以检索的属性，然后在转换
		List<SkuEsModel.Attrs> attrsList = baseAttrs.stream().filter(item -> {
			return idSet.contains(item.getAttrId());
		}).map(
				item -> {
					SkuEsModel.Attrs attr = new SkuEsModel.Attrs();
					BeanUtils.copyProperties(item, attr);
					return attr;
				}
		).collect(Collectors.toList());


		List<Long> skuIdList = skus.stream().map(SkuInfoEntity::getSkuId).collect(Collectors.toList());
		// TODO 1.发送远程调用，库存系统查询是否有库存
		Map<Long, Boolean> stockMap = null;
		try {
			List<Long> longList = skus.stream().map(SkuInfoEntity::getSkuId).collect(Collectors.toList());
			List<SkuHasStockVo> skuHasStocks = wareFeignService.getSkusHasStock(longList);
			stockMap = skuHasStocks.stream().collect(Collectors.toMap(SkuHasStockVo::getSkuId, SkuHasStockVo::getHasStock));
		} catch (Exception e) {
			log.error("库存服务查询异常，原因：", e);
		}


		// 封装每个sku 的信息
		Map<Long, Boolean> finalStockMap = stockMap;
		List<SkuEsModel> upProducts = skus.stream().map(sku -> {
			SkuEsModel em = new SkuEsModel();
			BeanUtils.copyProperties(sku, em);

			em.setSkuPrice(sku.getPrice());
			em.setSkuImg(sku.getSkuDefaultImg());
			// 设置库存信息
			if (finalStockMap == null) {
				em.setHasStock(true);
			} else {
				em.setHasStock(finalStockMap.get(sku.getSkuId()));

			}
			// TODO 2. 热度评分，0
			em.setHotScore(0L);
			// TODO 3.查询品牌的名称和分类信息
			BrandEntity brand = brandService.getById(em.getBrandId());
			em.setBrandName(brand.getName());
			em.setBrandImg(brand.getLogo());

			CategoryEntity category = categoryService.getById(em.getCatalogId());
			em.setCatalogName(category.getName());
			// 设置检索属性
			em.setAttrs(attrsList);
			return em;
		}).collect(Collectors.toList());

		// TODO 发给es 进行保存
		R r = searchFeignService.productStatusUp(upProducts);
		if (r.getCode() == 0) {
			// 远程调用成功
			// TODO 修改当前的spu 的状态
			this.baseMapper.updateSpuStatus(spuId, ProductConstant.StatusEnum.SPU_UP.getCode());
		} else {
			// 远程调用失败
			// TODO 重复调用，接口幂等性
		}
		;

	}

	@Override
	public SpuInfoEntity getSpuInfoBySkuId(Long skuId) {
		SkuInfoEntity byId = skuInfoService.getById(skuId);
		Long spuId = byId.getSpuId();
		SpuInfoEntity spuInfo = getById(spuId);
		return spuInfo;
	}


}
